<?php
require_once('../../conf/config.php.inc');
require_once(SYBMAS_LIB_PATH.'/liblogin.php.inc');
require_once(SYBMAS_LAYOUT_PATH.'/layout.php.inc');
require_once(SYBMAS_LIB_PATH.'/libsybmas.php.inc');
require_once(SYBMAS_LAYOUT_PATH.'/menu.php.inc');
require_once('libtablas.php.inc');
verificar_inicio_sesion();
?>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<link rel="stylesheet" type="text/css" href="<?php echo LAYOUT_URI?>/sybmasstyle.css">
<script src="<?php echo LAYOUT_URI?>/jquery-1.2.1.min.js" type="text/javascript"></script>
<script src="<?php echo LAYOUT_URI?>/menu-collapsed.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="<?php echo LAYOUT_URI?>/style.css" />
<script src="<?php echo JAVASCRIPT_URI?>/tabs/tabs.js"
	type="text/javascript"></script>
<script type="text/javascript" src="<?php echo JAVASCRIPT_URI?>/commons.js"></script>
<script type="text/javascript" src="<?php echo JAVASCRIPT_URI?>/validacionFormularios.js"></script>
<title>.:: Sybmas - Consulta de Bases de Datos</title>
<!--[if lt IE 8]>
   <style type="text/css">
   li a {display:inline-block;}
   li a {display:block;}
   </style>
   <![endif]-->
</head>
<body>
<script src="<?php echo JAVASCRIPT_URI?>/tooltip/wz_tooltip.js"
	type="text/javascript"></script>
<center>
<div id="container">
<div id="header">
<div id=""><?php generar_header();?></div>
</div>
<div id="scene">
<div id="modulos">
<ul id="menu" style="width: 150px;">
<?php generar_menu();?>
</ul>
</div>
<?php 		
  function combo(){	
  $query="SELECT name FROM master..sysdatabases";		
  echo "<select name='bd'>";
  $resultado=sybase_query($query);
  while ($fila=sybase_fetch_row($resultado)){				
    echo"<option value='$fila[0]'>$fila[0]";
				}				
			}
			echo "</select>";				
		?>	
<div id="title">Consulta de Bases de Datos</div>
<div id="main">
<?php 
$sybmas_connection=start_sybmas_connection();		    
?>
<h2>Consultar de Bases de Datos</h2>
<?php //$dbname=form_cambiarbd();?> 

<form name="formbd" method="POST" action=consultarBD.php>
<table width="80%" border="0">
  <tr>
    <td width="90">Base de Datos:</td>    
    <td width="40">
    	<input type="text" maxlength="30" name="bd" onkeypress="return onKeyPressPermiteAlfaNumericosNoEspacios(event)">
	</td>	    		
	<td><a href="#" onclick="formbd.submit();" ><span onmouseover="Tip('Buscar Base de Datos')" onmouseout="UnTip()">		
	<img src="<?php echo IMG_URI?>/page_white_magnify.png"
		 alt="Buscar" width="18" height="18" border="0" alt="Buscar"></span></a> Buscar</td>		        					     
  </tr>
</table>
</form> 
<p align=right><a href="crearBD.php"><img src="<?php echo IMG_URI?>/db_add.png" width="18" height="18" border="0"> Crear Bases de Datos</a></p>
<hr />
<?php 
   foreach($_POST as $key=>$value){
      $$key=$value;		
	}
	 
	$query="SELECT name,dbid,suid,crdate from master..sysdatabases ";
	
	if(!empty($bd)){	
		$query.="WHERE name LIKE '%".$bd."%'";		
	}
	$query.=" ORDER BY name ASC";				
?>
<?php 
//$cambio_bd_exitoso=true;
$sybuser_connection=start_default_sybuser_connection();
//if($dbname){
	//$cambio_bd_exitoso=sybase_select_db($dbname,$sybuser_connection);
//}
//if($cambio_bd_exitoso){
	$result=sybase_query($query,$sybuser_connection);
?>
<table width="80%" border="1">
	<tr>	    
		<th bgcolor="#8BA7C2">name</th>
		<th bgcolor="#8BA7C2">dbid</th>
		<th bgcolor="#8BA7C2">suid</th>
		<th bgcolor="#8BA7C2">crdate</th>	
		<th bgcolor="#8BA7C2"></th>	    	
	</tr>
	<?php
	while($data=sybase_fetch_array($result)){						
		?>	
	<tr>
	    <td><?php echo $data['name']?></td>
		<td><?php echo $data['dbid']?></td>
		<td><?php echo $data['suid']?></td>
		<td><?php echo $data['crdate']?></td>
			    				
		<td width="18">	
		<a href="bajabd.php?name=
		<?php 
			echo $data['name'];
			 //if($name){
			   //echo "&name=$name";	
			//}
		?>">
		<span onmouseover="Tip('Eliminar Base de Datos')" onmouseout="UnTip()"><img src="<?php echo IMG_URI?>/db_delete.png"
			alt="Eliminar BD" width="18" height="18" border="0" alt="Eliminar"></span>
		</a></td>			
	</tr>
	<?php
	}
	?>	
</table>         
<?php
  sybase_free_result($result);  
?> 

<?php
//Cerrando conexiones a la base de datos
sybase_close($sybuser_connection);
?></div>
</div>
<?php generar_footer();?></div>
</center>
</body>
</html>